﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_CM_AddClient]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_CM_AddClient];
GO
CREATE PROCEDURE [dbo].[sproc_CM_AddClient]
@birthday Datetime,
@chieflinkmanid int,
@UpdateTime datetime,
@AddmanID int,
@Shortname nvarchar(100),
@Name nvarchar(100),
@ContactTimes int,
@SellPhase nvarchar(100),
@BargainPrognosis nvarchar(100),
@Fee int,
@Linkman_Telephone nvarchar(100),
@CurStatus nvarchar(100),
@Type nvarchar(100),
@Affiliatedarea nvarchar(100),
@URL nvarchar(100),
@ZIP nvarchar(100),
@Address nvarchar(100),
@CompanyProperty nvarchar(100),
@Calling nvarchar(2000),
@CompanySize nvarchar(100),
@Money nvarchar(100),
@Operation nvarchar(100),
@Introduce nvarchar(1000),
@ITGrade nvarchar(1000),
@PCNumber int,
@Net nvarchar(100),
@ITStaffs int,
@ITDepartment nvarchar(100),
@Principal nvarchar(100),
@System nvarchar(1000),
@Customer nvarchar(100),
@ClientInitiative nvarchar(100)


AS
    INSERT INTO UDS_CM_ClientInfo(birthday,chieflinkmanid,UpdateTime,AddManID,ShortName,Name,ContactTimes,SellPhase,BargainPrognosis,Fee,Linkman_Telephone,CurStatus,Type,Affiliatedarea,URL,ZIP,Address,CompanyProperty,Calling,CompanySize,Money,Operation,Introduce,ITGrade,PCNumber,Net,ITStaffs,ITDepartment,Principal,System,Customer,ClientInitiative)
    VALUES(@birthday,@chieflinkmanid,@UpdateTime,@AddManID,@ShortName,@Name,@ContactTimes,@SellPhase,@BargainPrognosis,@Fee,@Linkman_Telephone,@CurStatus,@Type,@Affiliatedarea,@URL,@ZIP,@Address,@CompanyProperty,@Calling,@CompanySize,@Money,@Operation,@Introduce,@ITGrade,@PCNumber,@Net,@ITStaffs,@ITDepartment,@Principal,@System,@Customer,@ClientInitiative)
    RETURN @@IDENTITY